package com.example.springboot_zc.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.springboot_zc.pojo.ZyData;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface zydataMapper extends BaseMapper<ZyData> {

    @Delete("delete from zydata where stu_num=#{stuNum}")
    public Integer deleteByStu(String stuNum);
    @Select("SELECT class_num AS classNum,stu_num AS stuNum,xx_name AS xxName,content_sm AS contentSm,evi_mat AS eviMat,sug_score AS sugScore,zy_self_score AS zySelfScore,zy_bw_score AS zyBwScore,zy_new_time AS zyNewTime from zydata where stu_num=#{stuNum}")
    public List<ZyData> selectByStu(String stuNum);
}
